CustomerApi Odata Help Page

Customer - LoyaltyCardAction

LoyaltyCardAction entities

Required HTTP Headers

X-Crm360Api-Token
X-Crm360Api-CustomerName
X-Crm360Api-DatabaseAlias

Functions

Create
Read
Update
Delete

Entity Properties

Name	Type	Is Mandatory
LoyaltyCardActionId	Int32
LoyaltyCardId	Int32
LoyaltyCardActionTypeId	Int16
LoyaltyCardActionDate	DateTime
FreeField1	String
FreeField2	String
FreeField3	String
FreeField4	String
FreeField5	String
FreeFieldDateTime1	DateTime
FreeFieldDateTime2	DateTime
FreeFieldDateTime3	DateTime
FreeFieldDateTime4	DateTime
FreeFieldDateTime5	DateTime
FreeFieldNumber1	Decimal
FreeFieldNumber2	Decimal
FreeFieldNumber3	Decimal
FreeFieldNumber4	Decimal
FreeFieldNumber5	Decimal
FreeFieldBoolean1	Boolean
FreeFieldBoolean2	Boolean
FreeFieldBoolean3	Boolean
FreeFieldBoolean4	Boolean
FreeFieldBoolean5	Boolean
DeletionFlag	Boolean
LoyaltyCardHistoryIdentifier	String
SourceId	Int16
LoyaltyCard	LoyaltyCard
LoyaltyCardActionType	LoyaltyCardActionType
Source	Source

Examples

Select all LoyaltyCardActions
https://customerapi.fts-crm360.com/data/LoyaltyCardActions()
HttpMethod : GET                                                                                       
Json Result : 

[
{
"LoyaltyCardActionId" : "11",
"LoyaltyCardId" : "98",
"LoyaltyCardActionTypeId" : "8",
"LoyaltyCardActionDate" : "2023-06-27T00:00:00",
"FreeField1" : "LdEKA0ndVnrjeK",
"FreeField2" : "3 h0q9f0S3vC",
"FreeField3" : "6v8ThDOyLCub6XsfFT4",
"FreeField4" : "rN9SHAM8P3HEjgZ3uQ",
"FreeField5" : "Gwrr8yYvmyULk0KQswq",
"FreeFieldDateTime1" : "2000-03-30T00:00:00",
"FreeFieldDateTime2" : "2010-03-27T00:00:00",
"FreeFieldDateTime3" : "2020-02-11T00:00:00",
"FreeFieldDateTime4" : "2003-02-05T00:00:00",
"FreeFieldDateTime5" : "2011-05-09T00:00:00",
"FreeFieldNumber1" : "3968498.884",
"FreeFieldNumber2" : "8215157.362",
"FreeFieldNumber3" : "9763437.211",
"FreeFieldNumber4" : "4352412.546",
"FreeFieldNumber5" : "9542113.272",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "True",
"DeletionFlag" : "True",
"LoyaltyCardHistoryIdentifier" : "ZdJRstv6gn",
"SourceId" : "8"
},
{
"LoyaltyCardActionId" : "16",
"LoyaltyCardId" : "97",
"LoyaltyCardActionTypeId" : "3",
"LoyaltyCardActionDate" : "2001-08-04T00:00:00",
"FreeField1" : "8LYUVKV9fW3oK Xevr",
"FreeField2" : "BLXQ mSgaZAx1NVS",
"FreeField3" : "PTANHKwV0FvhPXZSkL",
"FreeField4" : "k5isCo4kdkAa0sb",
"FreeField5" : "bpg4Al5",
"FreeFieldDateTime1" : "2010-03-15T00:00:00",
"FreeFieldDateTime2" : "2010-11-11T00:00:00",
"FreeFieldDateTime3" : "2024-04-17T00:00:00",
"FreeFieldDateTime4" : "2000-06-17T00:00:00",
"FreeFieldDateTime5" : "1995-08-29T00:00:00",
"FreeFieldNumber1" : "6531671.769",
"FreeFieldNumber2" : "6363787.988",
"FreeFieldNumber3" : "2961379.962",
"FreeFieldNumber4" : "5676817.439",
"FreeFieldNumber5" : "4587974.322",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "False",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "False",
"DeletionFlag" : "True",
"LoyaltyCardHistoryIdentifier" : "Nu4tAHad6fAapCRq0",
"SourceId" : "4"
},
...
]

Select LoyaltyCardAction by Id
https://customerapi.fts-crm360.com/data/LoyaltyCardActions(11)
HttpMethod : GET                                                                                       
Json Result : 

{
"LoyaltyCardActionId" : "58",
"LoyaltyCardId" : "14",
"LoyaltyCardActionTypeId" : "9",
"LoyaltyCardActionDate" : "1997-12-03T00:00:00",
"FreeField1" : "Rp YV2dVqLPhpU",
"FreeField2" : "Z ZMAKZ3",
"FreeField3" : "Hj9U Th4GHnC",
"FreeField4" : "uFlbJWO",
"FreeField5" : "mVk JuvDb2xU",
"FreeFieldDateTime1" : "2002-05-16T00:00:00",
"FreeFieldDateTime2" : "2017-07-04T00:00:00",
"FreeFieldDateTime3" : "2021-04-05T00:00:00",
"FreeFieldDateTime4" : "1999-10-29T00:00:00",
"FreeFieldDateTime5" : "2005-03-11T00:00:00",
"FreeFieldNumber1" : "4644572.273",
"FreeFieldNumber2" : "6611616.967",
"FreeFieldNumber3" : "1282177.385",
"FreeFieldNumber4" : "3738161.116",
"FreeFieldNumber5" : "4854254.823",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "True",
"DeletionFlag" : "False",
"LoyaltyCardHistoryIdentifier" : "MY185UL 3TLBDBi2",
"SourceId" : "4"
}

Create a LoyaltyCardAction
https://customerapi.fts-crm360.com/data/LoyaltyCardActions()
HttpMethod : POST                                                                                                
Json Post :
{
"LoyaltyCardId" : "21",
"LoyaltyCardActionTypeId" : "7",
"LoyaltyCardActionDate" : "2006-03-05T00:00:00",
"FreeField1" : "iO5Jo",
"FreeField2" : "fb0d t1sNqcdRaPKPz",
"FreeField3" : "MD7PD",
"FreeField4" : "edL mCv",
"FreeField5" : "UdbctMVK1oV4u 7",
"FreeFieldDateTime1" : "2017-03-14T00:00:00",
"FreeFieldDateTime2" : "2006-04-23T00:00:00",
"FreeFieldDateTime3" : "2023-11-06T00:00:00",
"FreeFieldDateTime4" : "1998-01-07T00:00:00",
"FreeFieldDateTime5" : "1998-06-16T00:00:00",
"FreeFieldNumber1" : "4862843.378",
"FreeFieldNumber2" : "6678998.756",
"FreeFieldNumber3" : "7123924.154",
"FreeFieldNumber4" : "4696359.374",
"FreeFieldNumber5" : "8159172.959",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "True",
"DeletionFlag" : "True",
"LoyaltyCardHistoryIdentifier" : "RRm6PtOb9qDja",
"SourceId" : "1"
}
            
Informations : 
 - Non mandatory fields are optional for Json Post

Update a LoyaltyCardAction
https://customerapi.fts-crm360.com/data/LoyaltyCardActions(11)
HttpMethod : PUT                                                                                                
Json Post :
{
"LoyaltyCardActionId" : "57",
"LoyaltyCardId" : "3",
"LoyaltyCardActionTypeId" : "2",
"LoyaltyCardActionDate" : "2016-02-03T00:00:00",
"FreeField1" : "gPPM8cmhewLbN",
"FreeField2" : "n8DanXRgCBIXB6YoRxz",
"FreeField3" : "UADocoLvryO0vdal8u",
"FreeField4" : "OPtMK",
"FreeField5" : "jlGG5p",
"FreeFieldDateTime1" : "2007-01-06T00:00:00",
"FreeFieldDateTime2" : "2022-03-03T00:00:00",
"FreeFieldDateTime3" : "2013-01-25T00:00:00",
"FreeFieldDateTime4" : "2012-10-08T00:00:00",
"FreeFieldDateTime5" : "2021-01-10T00:00:00",
"FreeFieldNumber1" : "4992583.836",
"FreeFieldNumber2" : "6577576.668",
"FreeFieldNumber3" : "9841666.864",
"FreeFieldNumber4" : "8887571.179",
"FreeFieldNumber5" : "9455113.449",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "False",
"DeletionFlag" : "True",
"LoyaltyCardHistoryIdentifier" : "5m3QYN2zsrCIx",
"SourceId" : "6"
}
            
Informations : 
 - Non mandatory fields are optional for Json Post

Patch a LoyaltyCardAction
https://customerapi.fts-crm360.com/data/LoyaltyCardActions(11)
HttpMethod : PATCH                                                                                                
Json Post :
{
"SourceId" : "5",
"FreeFieldBoolean3" : "True",
"LoyaltyCardHistoryIdentifier" : "4gT3CeTIgmlh1Bu"
}
            
Informations : 
 - Non mandatory fields are optional for Json Post

Delete a LoyaltyCardAction
https://customerapi.fts-crm360.com/data/LoyaltyCardActions(11)
HttpMethod : DELETE